UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXCmu+c8S7ykYK+8J09hHFtXDJMFr57woVjbOFhhiQc='
WHERE
key_id = '3d956747ba015ba2b54079f4996d9d8f1b894f14e90e4c07493d05038c8a3114'
AND (
token = 'bXCmu+c8S7ykYK+8J09hHFtXDJMFr57woVjbOFhhiQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)