UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zi1xAgERjlF+C2tESU25BkG4jVR5UzSZxFCDe39CRtQ='
WHERE
key_id = '12c93f5e015ba31017f0d51f3f906283c3641659b6dd3db16659efae335e745c'
AND (
token = 'Zi1xAgERjlF+C2tESU25BkG4jVR5UzSZxFCDe39CRtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)