UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zI33Cn4V0/30T8V8RkeNUm8KUKf36dTBs9gUa5axcmc='
WHERE
key_id = 'c06579aec4acfe23733a0beb93ec9dc39b124bd22ea964a22a0a72398d76919e'
AND (
token = 'zI33Cn4V0/30T8V8RkeNUm8KUKf36dTBs9gUa5axcmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)