UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQvk78CK8INhc6E0sLTAYR3TuD49qrv9+8cvBROfiGI='
WHERE
key_id = 'ca1829018d9a738904218e121a087c4d5b57a05f57a460ca90521caaa7daab8b'
AND (
token = 'HQvk78CK8INhc6E0sLTAYR3TuD49qrv9+8cvBROfiGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)