UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hOCaNldlSuwv7PHSfPLmQry9kzRH3TuNrWraWwwSI4k='
WHERE
key_id = 'bf3d711f1df588f3f55d58452a84a11e200033d6233c8e4c7f7e646716bb4158'
AND (
token = 'hOCaNldlSuwv7PHSfPLmQry9kzRH3TuNrWraWwwSI4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)