UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vhRWtvy3TotUx0YhqnmCr4sYjBl/rIBG1nsxcIg5Dbk='
WHERE
key_id = 'dbb6c7c7f85e2fd727657cefd9b6d485fc44eb64ef806a7a10a7590a2bd0a7c5'
AND (
token = 'vhRWtvy3TotUx0YhqnmCr4sYjBl/rIBG1nsxcIg5Dbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)