UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OF1HT+YH6EAt+i1BtXtmyHEt91SVyVg3nrjsltdTX58='
WHERE
key_id = 'a29fd3ab482056dd34a5ed0176b3b0d96a5386f8ef8408a1c6e31b9a4b046977'
AND (
token = 'OF1HT+YH6EAt+i1BtXtmyHEt91SVyVg3nrjsltdTX58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)