UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'odgFYacCLYaHpiXFX63XijvgNK67omGtvHaySY8JNao='
WHERE
key_id = '9cae63b0b024a493c53a5371232fac16d2cf7122f6a70c3c53f801ea59ed4275'
AND (
token = 'odgFYacCLYaHpiXFX63XijvgNK67omGtvHaySY8JNao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)