UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4OCfk3qqUtp44xEvr9mUCO1lcnBHQ9xK6Ss523VTFs='
WHERE
key_id = '0c1766b76e451b3935c364c252d3ec511f5861d3bf18b8961ed89945de3556d4'
AND (
token = 'a4OCfk3qqUtp44xEvr9mUCO1lcnBHQ9xK6Ss523VTFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)