UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6AUSXErH24lRjB3XVHCXtv8qex33ICiGAWS3IK6ZDSk='
WHERE
key_id = 'b6c889dfc9e6118e59adbf45d9d921cd2573b959ba0abb5450369ae53ace4bf9'
AND (
token = '6AUSXErH24lRjB3XVHCXtv8qex33ICiGAWS3IK6ZDSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)