UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XbxmYM4oWFY/HPQEHnJwLnCEllr4HvJXYFaRqiBtE64='
WHERE
key_id = '1c5df8ee7e4f781b362c97c6aa6c7614c8ff1dee0ff1698e0dc7528dc0812af5'
AND (
token = 'XbxmYM4oWFY/HPQEHnJwLnCEllr4HvJXYFaRqiBtE64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)