UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nwi1Q+iUqxW9JA0ds8NNuauFOt9a961Io9r7BLK3ZNc='
WHERE
key_id = 'a6701f0c466fd5ab2368d714b69920405e971ed95cb0dab69a9a8032a5a12753'
AND (
token = 'nwi1Q+iUqxW9JA0ds8NNuauFOt9a961Io9r7BLK3ZNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)