UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Bs4OD/UXZlUF8L5k71nWrjEdWZQHkICj/iMCSLC2F0='
WHERE
key_id = '2f97b8ed849c98b9a42996b3768d7b51c31f2f82947358c95ea413a39f13d550'
AND (
token = '7Bs4OD/UXZlUF8L5k71nWrjEdWZQHkICj/iMCSLC2F0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)