UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCfJjNiDMWx97kvi44SnnCcrDhRNSH4R/bTbFBPVRuE='
WHERE
key_id = '827dc696a608b9d28b3708c92cb65a33c3bbd32b86ff17f61c0273f43b2861b6'
AND (
token = 'gCfJjNiDMWx97kvi44SnnCcrDhRNSH4R/bTbFBPVRuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)