UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CAs7sv0BB1qy7isqwaUw9EswD1MrWvN1nE9Tl2n0/Dg='
WHERE
key_id = '948d3802c06d9eb6780ed5c5ec5f0a3f4ac63a858ef01b2cc6c05b08bcf079ce'
AND (
token = 'CAs7sv0BB1qy7isqwaUw9EswD1MrWvN1nE9Tl2n0/Dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)