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