UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mKr7HSOVTugh/A8m0Baslr0YJ8pZy6V/KpxDjO/n1i8=' 
WHERE 
  key_id = 'd8aaab28d2dd11b77815f0142fc5b820747adab80fde3006c57a9e51f908885f' 
  AND (
    token = 'mKr7HSOVTugh/A8m0Baslr0YJ8pZy6V/KpxDjO/n1i8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036