UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZCxXb1kd4lHYRf75r1YorJohAh1wmBxGuLt6g9a7EI='
WHERE
key_id = '80750f5390ec339fd5e31de381324348571ceb678d5af5dbcb3941c1692b3168'
AND (
token = 'JZCxXb1kd4lHYRf75r1YorJohAh1wmBxGuLt6g9a7EI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)