UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zOQED8+b5iOr2IUmpzKr9QZTQY399j2nBj3iRH0m++E=' 
WHERE 
  key_id = '55915a3afd33aa5bef788ba4d60ab1ebdf807010a2521c1ebe7b60c7196524c9' 
  AND (
    token = 'zOQED8+b5iOr2IUmpzKr9QZTQY399j2nBj3iRH0m++E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041