UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9FR3fBpAz0s5CW07HRfhNezlYPJv1CJGyjFd2xMBDSE='
WHERE
key_id = '8e5bee20784cbb95c01d2407326ebfd9b5aa8b88bb6d4672ef44211537a1230b'
AND (
token = '9FR3fBpAz0s5CW07HRfhNezlYPJv1CJGyjFd2xMBDSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)