UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zMC3dUsH7ENIOYequW0XLWKFfwqis4qhGVMhCwmvquY='
WHERE
key_id = '0fad8298414dae9ce9e3943371c9857552bf26933af4da7b231fd54fbd0d4a1c'
AND (
token = 'zMC3dUsH7ENIOYequW0XLWKFfwqis4qhGVMhCwmvquY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)