UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0jT3cwPfqNO43ku8JjyJYt8064kQ1saMsO9j9AJ9XVQ='
WHERE
key_id = 'e5b01e94db339badd1a34a441307b6549431bf33a96b1fe1a5c780580d4c80d7'
AND (
token = '0jT3cwPfqNO43ku8JjyJYt8064kQ1saMsO9j9AJ9XVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)