UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/LVK8k5YjNxusmEqvE4ORU9sZyceww8ydguxPWpB/ac='
WHERE
key_id = '9931191f579b703109838374a8788ba92884f843c9e980a6a54bfab4ea95f00c'
AND (
token = '/LVK8k5YjNxusmEqvE4ORU9sZyceww8ydguxPWpB/ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)