UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nx3WlXigDSCMIrrXpIN2tifwlT+Fy6x9dABIXVSNtZ0='
WHERE
key_id = 'bb9d4acd506294f8654b04346f37f1bcbde01b5eba3f4c7c303605d6e861a79d'
AND (
token = 'nx3WlXigDSCMIrrXpIN2tifwlT+Fy6x9dABIXVSNtZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)