UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3G5WoKuxSophw/L7eQfyVGS37qB8HLD8MP+Rh52KA94='
WHERE
key_id = '5a4c90ae85c30baf7b8bb091057e16be6f95d423e1ede2976946ac7a2a616192'
AND (
token = '3G5WoKuxSophw/L7eQfyVGS37qB8HLD8MP+Rh52KA94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)