UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VLgqdydFLUd8JDj9PWYjl4d3rC3qbuPBtmoH2bj0LKA=' 
WHERE 
  key_id = '1e31779c68279c4bcd5519eb5f1bc4cbd716bfc0d7b5cdf3a03dfe2785b4e741' 
  AND (
    token = 'VLgqdydFLUd8JDj9PWYjl4d3rC3qbuPBtmoH2bj0LKA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041