UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fZDElM8K/u5AqvIhlbHFoZ0RgCEkMhhlI7T5HU65lxA='
WHERE
key_id = 'd9a01f45f6876517544f82ef49d9173d9c61c6602461d47d4e6e6c2d3b9a17bc'
AND (
token = 'fZDElM8K/u5AqvIhlbHFoZ0RgCEkMhhlI7T5HU65lxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)