UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJ379l8LJaRTLbWNHiCLuseA8ta5evf2mD1Qw3Bh91Q='
WHERE
key_id = 'f1c7eff91fa51d41919a0d610b7069377928e606c54a7a159c787a783de30667'
AND (
token = 'BJ379l8LJaRTLbWNHiCLuseA8ta5evf2mD1Qw3Bh91Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)