UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'odB1clNpubL7OdXVIN7WISq72hN4Uh316WbKt+Rhmtk=' 
WHERE 
  key_id = '4ca5d78145419ebb6758e60d78dff3dd32d06f635ffc4196378a169e6f41536e' 
  AND (
    token = 'odB1clNpubL7OdXVIN7WISq72hN4Uh316WbKt+Rhmtk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025